You are here: Main Menu > 2. Shipping Menu > S. Setup > Importing Item Info

Importing Item Info

This table is available to be imported or exported as part of the system initialization process. Use this process to quickly build the tables in your system. The following fields are defined in this table. If a field is REQUIRED, it must be supplied as part of the import process.

Select Phase 2 – Item Info when importing/exporting Item Info.

Screen Label Type Alias Field Req Default Possible Values Table Alias
Item Info C 1 InfoId Yes
Type C 1 InfoType Yes I S,I
Name C 15 InfoName Yes
10 character Text 1 Name C 13 InfoText1
Text 1 Field Column Sort Order C 1 Text1d 0 0,1,2,3,4,5,6,7,8,9
Text 1 Field on Unshipped Order C 1 UoTx1 Y Y,N,S
Text 1 Field on Pick List C 1 PlTx1   Y Y,N,S  
Text 1 Field on Load Sheet C 1 LsTx1 Y Y,N,S  
Text 1 Field on Shipped Order C 1 SoTx1 Y Y,N,S
Text 1 Field on Release C 1 RlTx1

 

Y Y,N,S  
Text 1 Field on BOL C 1 BlTx1 N Y,N,S
Text 1 Field on Invoice C 1 InTx1 Y Y,N,S
Text 1 Field on Purchase Order C 1 PoTx1 Y Y,N,S
Text 1 Field on Purchase Receiver C 1 RpTx1 Y Y,N,S
Text 1 Field on Completed Purchase C 1 CpTx1 Y Y,N,S
Text 1 Field on Purchase Vendor Copy C 1 VcTx1 Y Y,N,S
Text 1 Field on Work Order C 1 WoTx1   S Y,N,S  
Text 1 Field on Planned Transfer C 1 PtTx1   S Y,N,S  
Text 1 Field on Inventory Reports C 1 IrTx1   S Y,N,S  
Text 1 Field on Trace XML C 1 iit_tr_t1   N Y,N,S  
Text 1 Field Trace Product Attribute C 1 iit_tr_t1x     0=qualitygrade, 1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 5=fishinghmethod, 6=pondtank, 7=fdaclearance, 8=certificationnumber  
xx character Text 2 Name C 13 InfoText2
Text 2 Field Column Sort Order C 1 Text2d 0 0,1,2,3,4,5,6,7,8,9
Text 2 Field Column Width C 1 Text2l Y Y,N,S
Text 2 Field on Unshipped Order C 1 UoTx2 Y Y,N,S
Text 2 Field on Pick List C 1 PlTx2   Y Y,N,S  
Text 2 Field on Load Sheet C 1 LsTx2 Y Y,N,S  
Text 2 Field on Shipped Order C 1 SoTx2 Y Y,N,S
Text 2 Field on Release C 1 RlTx2

 

Y Y,N,S  
Text 2 Field on BOL C 1 BlTx2 N Y,N,S
Text 2 Field on Invoice C 1 InTx2 Y Y,N,S
Text 2 Field on Purchase Order C 1 PoTx2 Y Y,N,S
Text 2 Field on Purchase Receiver C 1 RpTx2 Y Y,N,S
Text 2 Field on Completed Purchase C 1 CpTx2 Y Y,N,S
Text 2 Field on Purchase Vendor Copy C 1 VcTx2 Y Y,N,S
Text 2 Field on Work Order C 1 WoTx2   S Y,N,S  
Text 2 Field on Planned Transfer C 1 PtTx2   S Y,N,S  
Text 2 Field on Inventory Reports C 1 IrTx2   S Y,N,S  
Text 2 Field on Trace XML C 1 iit_tr_t2   N Y,N,S  
Text 2 Field Trace Product Attribute C 1 iit_tr_t2x     1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 6=pondtank, 8=certificationnumber, 9=productionarea  
x character Text 3 Name C 13 InfoText3
Text 3 Field Column Sort Order C 1 Text3d 0 0,1,2,3,4,5,6,7,8,9
Text 3 Field on Unshipped Order C 1 UoTx3 N Y,N,S
Text 3 Field on Pick List C 1 PlTx3   Y Y.N,S  
Text 3 Field on Load Sheet C 1 LsTx3 N Y,N,S  
Text 3 Field on Shipped Order C 1 SoTx3 N Y,N,S
Text 3 Field on Release C 1 RlTx3

 

Y Y,N,S  
Text 3 Field on BOL C 1 BlTx3 N Y,N,S
Text 3 Field on Invoice C 1 InTx3 N Y,N,S
Text 3 Field on Purchase Order C 1 PoTx3 N Y,N,S
Text 3 Field on Purchase Receiver C 1 RpTx3 N Y,N,S
Text 3 Field on Completed Purchase C 1 CpTx3 N Y,N,S
Text 3 Field on Purchase Vendor Copy C 1 VcTx3 N Y,N,S
Text 3 Field on Work Order C 1 WoTx3   S Y,N,S  
Text 3 Field on Planned Transfer C 1 PtTx3   S Y,N,S  
Text 3 Field on Inventory Reports C 1 IrTx3   S Y,N,S  
Text 3 Field on Trace XML C 1 iit_tr_t3   N Y,N,S  
Text 3 Field Trace Product Attribute C 1 iit_tr_t3x     0=qualitygrade, 1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 5=fishinghmethod, 6=pondtank, 7=fdaclearance  
x character Text 4 Name C 13 InfoText4
Text 4 Field Column Sort Order C 1 Text4d 0 0,1,2,3,4,5,6,7,8,9
Text 4 Field on Unshipped Order C 1 UoTx4 Y Y,N,S
Text 4 Field on Pick List C 1 PlTx4   Y Y,N,S  
Text 4 Field on Load Sheet C 1 LsTx4 Y Y,N,S  
Text 4 Field on Shipped Order C 1 SoTx4 Y Y,N,S
Text 4 Field on Release C 1 RlTx4

 

Y Y,N,S  
Text 4 Field on BOL C 1 BlTx4 N Y,N,S
Text 4 Field on Invoice C 1 InTx4 Y Y,N,S
Text 4 Field on Purchase Order C 1 PoTx4 Y Y,N,S
Text 4 Field on Purchase Receiver C 1 RpTx4 Y Y,N,S
Text 4 Field on Completed Purchase C 1 CpTx4 Y Y,N,S
Text 4 Field on Purchase Vendor Copy C 1 VcTx4 N Y,N,S
Text 4 Field on Work Order C 1 WoTx4   S Y,N,S  
Text 4 Field on Planned Transfer C 1 PtTx4   S Y,N,S  
Text 4 Field on Inventory Reports C 1 IrTx4   S Y,N,S  
Text 4 Field on Trace XML C 1 iit_tr_t4   Y Y,N,S  
Text 4 Field Trace Product Attribute C 1 iit_tr_t4x     0=qualitygrade, 1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 5=fishinghmethod, 6=pondtank, 7=fdaclearance  
2 character Text 5 Name C 13 InfoText5
Text 5 Field Column Order C 1 Text5d 0 0,1,2,3,4,5,6,7,8,9
Text 5 Field on Unshipped Order C 1 UoTx5 Y Y,N,S
Text 5 Field on Pick List C ! PlTx5   Y Y,N,S  
Text 5 Field on Load Sheet C 1 LsTx5 Y Y,N,S  
Text 5 Field on Shipped Order C 1 SoTx5 Y Y,N,S
Text 5 Field on Release C 1 RlTx5

 

Y Y,N,S  
Text 5 Field on BOL C 1 BlTx5 N Y,N,S
Text 5 Field on Invoice C 1 InTx5 Y Y,N,S
Text 5 Field on Purchase Order C 1 PoTx5 Y Y,N,S
Text 5 Field on Purchase Receiver C 1 RpTx5 Y Y,N,S
Text 5 Field on Completed Purchase C 1 CpTx5 Y Y,N,S
Text 5 Field on Purchase Vendor Copy C 1 VcTx5 N Y,N,S
Text 5 Field on Work Order C 1 WoTx5 S Y,N,S  
Text 5 Field on Planned Transfer C 1 PtTx5 S Y,N,S  
Text 5 Field on Inventory Reports C 1 IrTx5 S Y,N,S  
Text 5 Field on Trace XML C 1 iit_tr_t5   Y Y,N,S  
Text 5 Field Trace Product Attribute C 1 iit_tr_t5x     0=qualitygrade, 1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 5=fishinghmethod, 6=pondtank, 7=fdaclearance  
8 character Text 6 Name C 13 InfoText6
Text 6 Field Column Order C 1 Text6d 0 0,1,2,3,4,5,6,7,8,9
Text 6 Field on Unshipped Order C 1 UoTx6 Y Y,N,S
Text 6 Field on Pick List C 1 PlTx6   Y Y,N,S  
Text 6 Field on Load Sheet C 1 LsTx6 Y Y,N,S  
Text 6 Field on Shipped Order C 1 SoTx6 Y Y,N,S
Text 6 Field on Release C 1 RlTx6   Y Y,N,S  
Text 6 Field on BOL C 1 BlTx6 N Y,N,S
Text 6 Field on Invoice C 1 InTx6 Y Y,N,S
Text 6 Field on Purchase Order C 1 PoTx6 Y Y,N,S
Text 6 Field on Purchase Receiver C 1 RpTx6 Y Y,N,S
Text 6 Field on Completed Purchase C 1 CpTx6 Y Y,N,S
Text 6 Field on Purchase Vendor Copy C 1 VcTx6 N Y,N,S
Text 6 Field on Work Order C 1 WoTx6 S Y,N,S  
Text 6 Field on Planned Transfer C 1 PtTx6 S Y,N,S  
Text 6 Field on Inventory Reports C 1 IrTx6 S Y,N,S  
Text 6 Field on Trace XML C 1 iit_tr_t6   N Y,N,S  
Text 6 Field Trace Product Attribute C 1 iit_tr_t6x     0=qualitygrade, 1=custom1, 2=custom2, 3=sizegrade, 4=productcondition, 5=fishinghmethod, 6=pondtank, 7=fdaclearance, 8=certificationnumber  
Date 1 Name C 13 InfoDate2
Date 1 Field Column Order C 1 Date1d 0 0,1,2,3,4,5,6,7,8,9
Date 1 Field on Unshipped Order C 1 UoDt1 Y Y,N,S
Date 1 Field on Load Sheet C 1 LsDt1 Y Y,N,S  
Date 1 Field on Pick List C 1 PlDt1   Y Y,N,S  
Date 1 Field on Shipped Order C 1 SoDt1 Y Y,N,S
Date 1 Field on Release C 1 RlDt1

 

Y Y,N,S  
Date 1 Field on BOL C 1 BlDt1 N Y,N,S
Date 1 Field on Invoice C 1 InDt1 Y Y,N,S
Date 1 Field on Purchase Order C 1 PoDt1 Y Y,N,S
Date 1 Field on Purchase Receiver C 1 RpDt1 Y Y,N,S
Date 1 Field on Completed Purchase C 1 CpDt1 Y Y,N,S
Date 1 Field on Purchase Vendor Copy C 1 VcDt1 Y Y,N,S
Date 1 Field on Work Orders C 1 WoDt1 S Y,N,S  
Date 1 Field on Planned Transfer C 1 PtDt1 S Y,N,S  
Date 1 Field on Inventory Reports C 1 IrDt1 S Y,N,S  
Date 1 Field on Trace XML C 1 iit_tr_d1   N Y,N  
Date 1 Field Trace Product Attribute C 1 iit_tr_d1x    

A=HarvestDate

B=ProductionDate

 
Date 2 Name C 13 InfoDate2
Date 2 Field Column Order C 1 Date2d 0 0,1,2,3,4,5,6,7,8,9
Date 2 Field on Unshipped Order C 1 UoDt2 Y Y,N,S
Date 2 Field on Pick List C 1 PlDt2   Y Y,N,S  
Date 2 Field on Load Sheet C 1 LsDt2 Y Y,N,S  
Date 2 Field on Shipped Order C 1 SoDt2 Y Y,N,S
Date 2 Field on Release C 1 RlDt2   Y Y,N,S  
Date 2 Field on BOL C 1 BlDt2 N Y,N,S
Date 2 Field on Invoice C 1 InDt2 Y Y,N,S
Date 2 Field on Purchase Order C 1 PoDt2 Y Y,N,S
Date 2 Field on Purchase Receiver C 1 RpDt2 Y Y,N,S
Date 2 Field on Completed Purchase C 1 CpDt2 Y Y,N,S
Date 2 Field on Purchase Vendor Copy C 1 VcDt2 Y Y,N,S
Date 2 Field on Work Order C 1 WoDt2 S Y,N,S  
Date 2 Field on Planned Transfer C 1 PtDt2 S Y,N,S  
Date 2 Field on Inventory Reports C 1 IrDt2 S Y,N,S  
Date 2 Field on Inventory Reports C 1 iit_tr_d2   N Y,N  
Date 2 Field Trace Product Attribute C 1 iit_tr_d2x     A=HarvestDate, B=ProductionDate  
Lot Number on Unshipped Order C 1 UoLot Y Y,N,S
Lot Number on Pick List C 1 Pllot   Y Y,N,S  
Lot Number on Load Sheet C 1 LsLot Y Y,N,S  
Lot Number on Shipped Order C 1 SoLot Y Y,N,S
Lot Number on BOL C 1 BlLot N Y,N,S
Lot Number on Invoice C 1 InLot Y Y,N,S
Lot Number on Purchase Order C 1 PoLot Y Y,N,S
Lot Number on Purchase Receiver C 1 RpLot Y Y,N,S
Lot Number on Completed Purchase C 1 CpLot Y Y,N,S
Lot Number on Purchase Vendor Copy C 1 VcLot Y Y,N,S
Ordered Quantity on Unshipped Order C 1 UoOQty Y Y,N
Ordered Quantity on Pick List C 1 PlOQty   y Y,N  
Ordered Quantity on Load Sheet C 1 LsOQty Y Y,N  
Ordered Quantity on Shipped Order C 1 SoOQty Y Y,N
Ordered Quantity on Release C 1 RlOQty

 

Y Y,N  
Ordered Quantity on BOL C 1 BlOQty N Y,N
Ordered Quantity on Invoice C 1 InOQty Y Y,N
Ordered Quantity on Purchase Order C 1 PoOQty Y Y,N
Ordered Quantity on Purchase Receiver C 1 RpOQty Y Y,N
Ordered Quantity on Completed Purchase C 1 CpOQty N Y,N
Ordered Quantity on Purchase Vendor Copy C 1 VcOQty Y Y,N
Ordered Quantity on Work Order C 1 WoOQty Y Y,N  
Ordered Quantity on Planned Transfer C 1 PtOQty Y Y,N  
Pricing Quantity on Unshipped Order C 1 UoPQty Y Y,N
Pricing Quantity on Pick List C 1 PlPQty   Y Y,N  
Pricing Quantity on Load Sheet C 1 LsPQty Y Y,N  
Pricing Quantity on Shipped Order C 1 SoPQty Y Y,N
Pricing Quantity on Release C 1 RlPQty

 

Y Y,N  
Pricing Quantity on BOL C 1 BlPQty Y Y,N
Pricing Quantity on Invoice C 1 InPQty Y Y,N
Pricing Quantity on Purchase Order C 1 PoPQty Y Y,N
Pricing Quantity on Purchase Receiver C 1 RpPQty Y Y,N
Pricing Quantity on Completed Purchase C 1 CpPQty Y Y,N
Pricing Quantity on Purchase Vendor Copy C 1 VcPQty Y Y,N
Pricing Quantity on Work Order C 1 WoPQty Y Y,N  
Pricing Quantity on Planned Transfer C 1 PtPQty Y Y,N  
Stocking Quantity on Unshipped Order C 1 UoSQty N Y,N
Stocking Quantity on Pick List C 1 PlSQty   N Y,N  
Stocking Quantity on Load Sheet C 1 LsSQty N Y,N  
Stocking Quantity on Shipped Order C 1 SoSQty N Y,N
Stocking Quantity on Release C 1 RlSQty

 

N Y,N  
Stocking Quantity on BOL C 1 BlSQty N Y,N
Stocking Quantity on Invoice C 1 InSQty N Y,N
Stocking Quantity on Purchase Order C 1 PoSQty N Y,N
Stocking Quantity on Purchase Receiver C 1 RpSQty N Y,N
Stocking Quantity on Completed Purchase C 1 CpSQty N Y,N
Stocking Quantity on Purchase Vendor Copy C 1 VcSQty N Y,N
Stocking Quantity on Work Order C 1 WoSQty Y Y,N  
Stocking Quantity on Planned Transfer C 1 PtSQty Y Y,N  
Weight Quantity on Unshipped Order C 1 UoWQty N Y,N
Weight Quantity on Pick List C 1 PlWQty   N Y,N  
Weight Quantity on Load Sheet C 1 LsWQty N Y,N  
Weight Quantity on Shipped Order C 1 SoWQty N Y,N
Weight Quantity on Release C 1 RlWQty

 

N Y,N  
Weight Quantity on BOL C 1 BlWQty N Y,N
Weight Quantity on Invoice C 1 InWQty N Y,N
Weight Quantity on Purchase Order C 1 PoWQty N Y,N
Weight Quantity on Purchase Receiver C 1 RpWQty N Y,N
Weight Quantity on Completed Purchase C 1 CpWQty N Y,N
Weight Quantity on Purchase Vendor Copy C 1 VcWQty N Y,N
Weight Quantity on Work Order C 1 WoWQty Y Y,N  
Weight Quantity on Planned Transfer C 1 PtWQty Y Y,N  
Sell by Date on Unshipped Order C 1 UoSBy   N

N = Not Using

S = Ship Date

Y = Ship Date if unlotted or Lot Date if lotted

1 = Date1

2 = Date2

 
Sell by Date on Shipped Order C 1 SoSby   N  

N = Not Using

S = Ship Date

Y = Ship Date if unlotted or Lot Date if lotted

1 = Date1

2 = Date2

 
Sell by Date on BOL C 1 BlSBy   N  

N = Not Using

S = Ship Date

Y = Ship Date if unlotted or Lot Date if lotted

1 = Date1

2 = Date2

 
Sell by Date on Invoice C 1 InSBy   N  

N = Not Using

S = Ship Date

Y = Ship Date if unlotted or Lot Date if lotted

1 = Date1

2 = Date2

 
Sell by Date on Trace XML C 1 TrSBy   N  

N = Not Using

S = Ship Date

Y = Ship Date if unlotted or Lot Date if lotted

1 = Date1

2 = Date2

 
Cool Field Column Sort Order C 1 Coold 0 0,1,2,3,4,5,6,7,8,9
Print COOL on Unshipped Orders C 1 UoC00   N

E = English Only

A = Alias Only

B = Both

N = Not Using

 
Print COOL on Pick List C 1 PlCoo   N  

E = English Only

A = Alias Only

B = Both

N = Not Using

 
Print COOL on Load Sheet C 1 LsCoo   N  

E = English Only

A = Alias Only

B = Both

N = Not Using

 
Print COOL on Shipped Orders C 1 SoCoo   N  

E = English Only

A = Alias Only

B = Both

N = Not Using

 
Include COOL on Trace XML C 1 TrCoo   N Y,N  
Dealer Id C 12 Dealer
Trace Item Code Name C 13 TrIcn     Item Code  
Trace Item Code Length N 2 TrIcl   8 8-25  
Trace Item Code Source C 1 TrIcs   V

A = Ask

V = Vendor Item Alias

I = Item

1 = Text1

2 = Text2

6 = Text6

N = Not Using

 
Trace Purchase Order Number Name C 13 TrPon     PO Number  
Trace Purchase Order Number Length N 2 TrPol   5 5-50  
Trace Purchase Order Source C 1 TrPos   T

A = Ask

T = Transaction

1 = Text1

2 = Text2

3 = Text3

4 = Text4

6 = Text6

N = Not Using

 
Trace Production Date Name C 13 TrPdn     Prod Date  
Trace Production Date Source C 1 TrPds   N

A = Ask

7 = Date1

8 = Date2

N = Not Using

 
Trace Batch Number Name C 13 TrBnn     Lot Number  
Trace Batch Number Length N 2 TrBnl   12 8-50  
Trace Batch Number Source C 1 TrBns   N

A = Ask

1 = Text1

2 = Text2

3 = Text3

4 = Text4

6 = Text6

N = Not Using

 
Trace Custom 1 Field Name C 13 TrC1n     Custom1  
Trace Custom1 Length N 2 TrC1l   10 1-50  
Trace Custom1 Source C 1 TrC1s   N

A = Ask

1 = Text1

2 = Text2

3 = Text3

4 = Text4

6 = Text6

N = Not Using

 
Trace Custom2 Field Name C 13 TrC2n     Custom2  
Trace Custom2 Length N 2 Tr21l   10 1-50  
Trace Custom2 Source C 1 TrC2s   N

A = Ask

1 = Text1

2 = Text2

3 = Text3

4 = Text4

6 = Text6

N = Not Using

 

Security Required : System - System Administration

See Also Used In